// 蜂窝蜜造平台生成代码，如手工更改，请添加到 .beeignore 忽略生成

package com.fowo.api.pda.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.fowo.api.inventory.entity.InventoryPlacement;
import com.fowo.api.inventory.model.*;
import com.fowo.api.pda.model.InventoryBo;
import com.fowo.api.pda.model.InventoryPlacementItemVo;
import com.fowo.api.pda.model.ProductInventoryVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;

@Mapper
public interface PdaInventoryMapper extends BaseMapper<InventoryPlacement> {

    /**
     * 查询SKU总库存
     * @param sku
     * @return
     */
    List<ProductInventoryVo> selectProductInventoryVoBySku(String sku);
    /**
     * 根据产品查询当前仓库库存
     * @param search
     * @return
     */
    List<InventoryPlacementItemVo> selectInventoryByProduct(InventoryBo search);

    /**
     * 根据仓位查询当前仓库库存
     * @param stockId
     * @param binId
     * @return
     */
    List<InventoryPlacementItemVo> selectInventoryByBin(Long stockId,Long binId);

    /**
     * 查询产品库存
     * @param search
     * @return
     */
    List<InventoryPlacementItemVo> selectInventoryPlacementItemVo(InventoryBo search);

    List<ProductInventoryVo> selectShopInventory(Long stockId,String sku);

    List<InventoryPlacement> selectInventoryPlacement(InventoryBo search);
}
